
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspSiteUserAccessRole_INSERT
(
@roleId AS int = null,
@userId AS int = null,
@createDate AS datetime = null
)
AS

INSERT INTO
  [dbo].[SiteUser_AccessRole]
(
  [RoleId],
  [UserId],
  [CreateDate]
)
VALUES
(
  @roleId,
  @userId,
  @createDate
)

SELECT SCOPE_IDENTITY()

GO
